Name | Description |
BaseSQL (inherited from TCustomDADataSet) |
Used to return SQL text without any changes performed by AddWhere, SetOrderBy, and FilterSQL.
|
CachedUpdates (inherited from TMemDataSet) |
Used to enable or disable the use of cached updates for a dataset.
|
CommandTimeout |
Used to specify the amount of time to attempt execution of a command.
|
Conditions (inherited from TCustomDADataSet) |
Used to add WHERE conditions to a query
|
Connection |
Used to specify a connection object that will be used to connect to a data store.
|
DataTypeMap (inherited from TCustomDADataSet) |
Used to set data type mapping rules
|
Debug (inherited from TCustomDADataSet) |
Used to display the statement that is being executed and the values and types of its parameters.
|
DetailFields (inherited from TCustomDADataSet) |
Used to specify the fields that correspond to the foreign key fields from MasterFields when building master/detail relationship.
|
Disconnected (inherited from TCustomDADataSet) |
Used to keep dataset opened after connection is closed.
|
Encryption |
Used to specify encryption options in a dataset.
|
FetchAll |
Defines whether to request all records of the query from database server when the dataset is being opened.
|
FetchRows (inherited from TCustomDADataSet) |
Used to define the number of rows to be transferred across the network at the same time.
|
FilterSQL (inherited from TCustomDADataSet) |
Used to change the WHERE clause of SELECT statement and reopen a query.
|
FinalSQL (inherited from TCustomDADataSet) |
Used to return SQL text with all changes performed by AddWhere, SetOrderBy, and FilterSQL, and with expanded macros.
|
IndexFieldNames (inherited from TMemDataSet) |
Used to get or set the list of fields on which the recordset is sorted.
|
InsertId |
Returns the ID generated for an AUTO_INCREMENT column by the previous query.
|
IsQuery (inherited from TCustomDADataSet) |
Used to check whether SQL statement returns rows.
|
KeyExclusive (inherited from TMemDataSet) |
Specifies the upper and lower boundaries for a range.
|
KeyFields (inherited from TCustomDADataSet) |
Used to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating the database.
|
LocalConstraints (inherited from TMemDataSet) |
Used to avoid setting the Required property of a TField component for NOT NULL fields at the time of opening TMemDataSet.
|
LocalUpdate (inherited from TMemDataSet) |
Used to prevent implicit update of rows on database server.
|
LockMode |
Specifies when to perform locking of an editing record.
|
MacroCount (inherited from TCustomDADataSet) |
Used to get the number of macros associated with the Macros property.
|
Macros (inherited from TCustomDADataSet) |
Makes it possible to change SQL queries easily.
|
MasterFields (inherited from TCustomDADataSet) |
Used to specify the names of one or more fields that are used as foreign keys for dataset when establishing detail/master relationship between it and the dataset specified in MasterSource.
|
MasterSource (inherited from TCustomDADataSet) |
Used to specify the data source component which binds current dataset to the master one.
|
Options |
Specifies the behaviour of TCustomMyDataSet object.
|
ParamCheck (inherited from TCustomDADataSet) |
Used to specify whether parameters for the Params property are generated automatically after the SQL property was changed.
|
ParamCount (inherited from TCustomDADataSet) |
Used to indicate how many parameters are there in the Params property.
|
Params (inherited from TCustomDADataSet) |
Used to view and set parameter names, values, and data types dynamically.
|
Prepared (inherited from TMemDataSet) |
Determines whether a query is prepared for execution or not.
|
Ranged (inherited from TMemDataSet) |
Indicates whether a range is applied to a dataset.
|
ReadOnly (inherited from TCustomDADataSet) |
Used to prevent users from updating, inserting, or deleting data in the dataset.
|
RefreshOptions (inherited from TCustomDADataSet) |
Used to indicate when the editing record is refreshed.
|
RowsAffected (inherited from TCustomDADataSet) |
Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.
|
SmartFetch |
The SmartFetch mode is used for fast navigation through a huge amount of records and to minimize memory consumption.
|
SQL (inherited from TCustomDADataSet) |
Used to provide a SQL statement that a query component executes when its Open method is called.
|
SQLDelete (inherited from TCustomDADataSet) |
Used to specify a SQL statement that will be used when applying a deletion to a record.
|
SQLInsert (inherited from TCustomDADataSet) |
Used to specify the SQL statement that will be used when applying an insertion to a dataset.
|
SQLLock (inherited from TCustomDADataSet) |
Used to specify a SQL statement that will be used to perform a record lock.
|
SQLRecCount (inherited from TCustomDADataSet) |
Used to specify the SQL statement that is used to get the record count when opening a dataset.
|
SQLRefresh (inherited from TCustomDADataSet) |
Used to specify a SQL statement that will be used to refresh current record by calling the TCustomDADataSet.RefreshRecord procedure.
|
SQLUpdate (inherited from TCustomDADataSet) |
Used to specify a SQL statement that will be used when applying an update to a dataset.
|
UniDirectional (inherited from TCustomDADataSet) |
Used if an application does not need bidirectional access to records in the result set.
|
UpdateObject |
Used to specify an update object component which provides SQL statements that perform updates of the read-only datasets.
|
UpdateRecordTypes (inherited from TMemDataSet) |
Used to indicate the update status for the current record when cached updates are enabled.
|
UpdatesPending (inherited from TMemDataSet) |
Used to check the status of the cached updates buffer.
|